<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.6"/>
<title>SystemSharp: SQLite.SQLiteConnection Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
  $(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="logo.png"/></td>
  <td style="padding-left: 0.5em;">
   <div id="projectname">SystemSharp
   &#160;<span id="projectnumber">0.3</span>
   </div>
   <div id="projectbrief">A system-level modeling framework for designing real-time embedded systems</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.6 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Packages</span></a></li>
      <li class="current"><a href="annotated.html"><span>Classes</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>Class&#160;List</span></a></li>
      <li><a href="classes.html"><span>Class&#160;Index</span></a></li>
      <li><a href="hierarchy.html"><span>Class&#160;Hierarchy</span></a></li>
      <li><a href="functions.html"><span>Class&#160;Members</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('class_s_q_lite_1_1_s_q_lite_connection.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&#160;</span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&#160;</span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&#160;</span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark">&#160;</span>Properties</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(10)"><span class="SelectionMark">&#160;</span>Events</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="summary">
<a href="#nested-classes">Classes</a> &#124;
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#pro-methods">Protected Member Functions</a> &#124;
<a href="#properties">Properties</a> &#124;
<a href="class_s_q_lite_1_1_s_q_lite_connection-members.html">List of all members</a>  </div>
  <div class="headertitle">
<div class="title">SQLite.SQLiteConnection Class Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>Represents an open connection to a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database.  
 <a href="class_s_q_lite_1_1_s_q_lite_connection.html#details">More...</a></p>
<div class="dynheader">
Inheritance diagram for SQLite.SQLiteConnection:</div>
<div class="dyncontent">
 <div class="center">
  <img src="class_s_q_lite_1_1_s_q_lite_connection.png" usemap="#SQLite.SQLiteConnection_map" alt=""/>
  <map id="SQLite.SQLiteConnection_map" name="SQLite.SQLiteConnection_map">
<area href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html" alt="SQLite.SQLiteConnectionWithLock" shape="rect" coords="0,112,207,136"/>
</map>
 </div></div>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="nested-classes"></a>
Classes</h2></td></tr>
<tr class="memitem:"><td class="memItemLeft" align="right" valign="top">class &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_1_1_column_info.html">ColumnInfo</a></td></tr>
<tr class="separator:"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr class="memitem:a21204da14d0e2a44039f3395bb4ff12d"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a21204da14d0e2a44039f3395bb4ff12d">SQLiteConnection</a> (string databasePath, bool storeDateTimeAsTicks=false)</td></tr>
<tr class="memdesc:a21204da14d0e2a44039f3395bb4ff12d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath.  <a href="#a21204da14d0e2a44039f3395bb4ff12d">More...</a><br/></td></tr>
<tr class="separator:a21204da14d0e2a44039f3395bb4ff12d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5d0deb6299d3f479e53cf81899023457"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a5d0deb6299d3f479e53cf81899023457">SQLiteConnection</a> (string databasePath, <a class="el" href="namespace_s_q_lite.html#a9d72cc097c53dbc96a6f0eec530cc439">SQLiteOpenFlags</a> openFlags, bool storeDateTimeAsTicks=false)</td></tr>
<tr class="memdesc:a5d0deb6299d3f479e53cf81899023457"><td class="mdescLeft">&#160;</td><td class="mdescRight">Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath.  <a href="#a5d0deb6299d3f479e53cf81899023457">More...</a><br/></td></tr>
<tr class="separator:a5d0deb6299d3f479e53cf81899023457"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a25b7a6e9e1fa2e2ead47bb1821822fc6"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a25b7a6e9e1fa2e2ead47bb1821822fc6">GetMapping</a> (Type type)</td></tr>
<tr class="memdesc:a25b7a6e9e1fa2e2ead47bb1821822fc6"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the mapping that is automatically generated for the given type.  <a href="#a25b7a6e9e1fa2e2ead47bb1821822fc6">More...</a><br/></td></tr>
<tr class="separator:a25b7a6e9e1fa2e2ead47bb1821822fc6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:adf0ed08567e1ca36e4fda72c94ede544"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#adf0ed08567e1ca36e4fda72c94ede544">GetMapping&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:adf0ed08567e1ca36e4fda72c94ede544"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the mapping that is automatically generated for the given type.  <a href="#adf0ed08567e1ca36e4fda72c94ede544">More...</a><br/></td></tr>
<tr class="separator:adf0ed08567e1ca36e4fda72c94ede544"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a783032226b2db2ebd6417f21abe9cd5a"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a783032226b2db2ebd6417f21abe9cd5a">DropTable&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:a783032226b2db2ebd6417f21abe9cd5a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "drop table" on the database. This is non-recoverable.  <a href="#a783032226b2db2ebd6417f21abe9cd5a">More...</a><br/></td></tr>
<tr class="separator:a783032226b2db2ebd6417f21abe9cd5a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1a76c62e25bff4f6bbf5366175ab3bf7"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1a76c62e25bff4f6bbf5366175ab3bf7">CreateTable&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:a1a76c62e25bff4f6bbf5366175ab3bf7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.  <a href="#a1a76c62e25bff4f6bbf5366175ab3bf7">More...</a><br/></td></tr>
<tr class="separator:a1a76c62e25bff4f6bbf5366175ab3bf7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3e1bbdd7aebce4f815ca35b8277e1270"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a3e1bbdd7aebce4f815ca35b8277e1270">CreateTable</a> (Type ty)</td></tr>
<tr class="memdesc:a3e1bbdd7aebce4f815ca35b8277e1270"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.  <a href="#a3e1bbdd7aebce4f815ca35b8277e1270">More...</a><br/></td></tr>
<tr class="separator:a3e1bbdd7aebce4f815ca35b8277e1270"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af85031e61990a4d11d10533da5acb21c"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_1_1_column_info.html">ColumnInfo</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af85031e61990a4d11d10533da5acb21c">GetTableInfo</a> (string tableName)</td></tr>
<tr class="separator:af85031e61990a4d11d10533da5acb21c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a112ac999fccd302bda742992f044f3ee"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a112ac999fccd302bda742992f044f3ee">CreateCommand</a> (string cmdText, params object[] ps)</td></tr>
<tr class="memdesc:a112ac999fccd302bda742992f044f3ee"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text with arguments. Place a '?' in the command text for each of the arguments.  <a href="#a112ac999fccd302bda742992f044f3ee">More...</a><br/></td></tr>
<tr class="separator:a112ac999fccd302bda742992f044f3ee"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5fbb3e385d21cfbee95e4a2a71a3043b"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a5fbb3e385d21cfbee95e4a2a71a3043b">Execute</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:a5fbb3e385d21cfbee95e4a2a71a3043b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. Use this method instead of Query when you don't expect rows back. Such cases include INSERTs, UPDATEs, and DELETEs. You can set the Trace or TimeExecution properties of the connection to profile execution.  <a href="#a5fbb3e385d21cfbee95e4a2a71a3043b">More...</a><br/></td></tr>
<tr class="separator:a5fbb3e385d21cfbee95e4a2a71a3043b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af88acbe7da213c81875c3a35a5d61337"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af88acbe7da213c81875c3a35a5d61337">ExecuteScalar&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="separator:af88acbe7da213c81875c3a35a5d61337"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ade363948abe65a6b97fe8574f943db91"><td class="memItemLeft" align="right" valign="top">List&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ade363948abe65a6b97fe8574f943db91">Query&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:ade363948abe65a6b97fe8574f943db91"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.  <a href="#ade363948abe65a6b97fe8574f943db91">More...</a><br/></td></tr>
<tr class="separator:ade363948abe65a6b97fe8574f943db91"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a334b139ead4620ad13b5e1d54e8077af"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a334b139ead4620ad13b5e1d54e8077af">DeferredQuery&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:a334b139ead4620ad13b5e1d54e8077af"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.  <a href="#a334b139ead4620ad13b5e1d54e8077af">More...</a><br/></td></tr>
<tr class="separator:a334b139ead4620ad13b5e1d54e8077af"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aeac8a5ef1be5cfabc5bbf33f1fec01b0"><td class="memItemLeft" align="right" valign="top">List&lt; object &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aeac8a5ef1be5cfabc5bbf33f1fec01b0">Query</a> (<a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map, string query, params object[] args)</td></tr>
<tr class="memdesc:aeac8a5ef1be5cfabc5bbf33f1fec01b0"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.  <a href="#aeac8a5ef1be5cfabc5bbf33f1fec01b0">More...</a><br/></td></tr>
<tr class="separator:aeac8a5ef1be5cfabc5bbf33f1fec01b0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab359d97e7938a573e0a565d2c46aa401"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; object &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab359d97e7938a573e0a565d2c46aa401">DeferredQuery</a> (<a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map, string query, params object[] args)</td></tr>
<tr class="memdesc:ab359d97e7938a573e0a565d2c46aa401"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.  <a href="#ab359d97e7938a573e0a565d2c46aa401">More...</a><br/></td></tr>
<tr class="separator:ab359d97e7938a573e0a565d2c46aa401"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab44d5100216c3cdcea76e45c6f7d6246"><td class="memItemLeft" align="right" valign="top">TableQuery&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab44d5100216c3cdcea76e45c6f7d6246">Table&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:ab44d5100216c3cdcea76e45c6f7d6246"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns a queryable interface to the table represented by the given type.  <a href="#ab44d5100216c3cdcea76e45c6f7d6246">More...</a><br/></td></tr>
<tr class="separator:ab44d5100216c3cdcea76e45c6f7d6246"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a17fdec8364635853d573e84530e1ab48"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a17fdec8364635853d573e84530e1ab48">Get&lt; T &gt;</a> (object pk)</td></tr>
<tr class="memdesc:a17fdec8364635853d573e84530e1ab48"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#a17fdec8364635853d573e84530e1ab48">More...</a><br/></td></tr>
<tr class="separator:a17fdec8364635853d573e84530e1ab48"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4034d4b62385b2ab7451c5404ffb5efa"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a4034d4b62385b2ab7451c5404ffb5efa">Get&lt; T &gt;</a> (Expression&lt; Func&lt; T, bool &gt;&gt; predicate)</td></tr>
<tr class="memdesc:a4034d4b62385b2ab7451c5404ffb5efa"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.  <a href="#a4034d4b62385b2ab7451c5404ffb5efa">More...</a><br/></td></tr>
<tr class="separator:a4034d4b62385b2ab7451c5404ffb5efa"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:adfe66fe8c304aca8575f07fc1c05d9f5"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#adfe66fe8c304aca8575f07fc1c05d9f5">Find&lt; T &gt;</a> (object pk)</td></tr>
<tr class="memdesc:adfe66fe8c304aca8575f07fc1c05d9f5"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#adfe66fe8c304aca8575f07fc1c05d9f5">More...</a><br/></td></tr>
<tr class="separator:adfe66fe8c304aca8575f07fc1c05d9f5"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a95729c5ebf5fad75631109db91e7c14b"><td class="memItemLeft" align="right" valign="top">object&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a95729c5ebf5fad75631109db91e7c14b">Find</a> (object pk, <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map)</td></tr>
<tr class="memdesc:a95729c5ebf5fad75631109db91e7c14b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#a95729c5ebf5fad75631109db91e7c14b">More...</a><br/></td></tr>
<tr class="separator:a95729c5ebf5fad75631109db91e7c14b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca">Find&lt; T &gt;</a> (Expression&lt; Func&lt; T, bool &gt;&gt; predicate)</td></tr>
<tr class="memdesc:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.  <a href="#aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca">More...</a><br/></td></tr>
<tr class="separator:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aba3becdb524808bd49f349587f1b7049"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049">BeginTransaction</a> ()</td></tr>
<tr class="memdesc:aba3becdb524808bd49f349587f1b7049"><td class="mdescLeft">&#160;</td><td class="mdescRight">Begins a new transaction. Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a> to end the transaction.  <a href="#aba3becdb524808bd49f349587f1b7049">More...</a><br/></td></tr>
<tr class="separator:aba3becdb524808bd49f349587f1b7049"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab571412a681990a95131ded731ad6c4a"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a">SaveTransactionPoint</a> ()</td></tr>
<tr class="memdesc:ab571412a681990a95131ded731ad6c4a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress.  <a href="#ab571412a681990a95131ded731ad6c4a">More...</a><br/></td></tr>
<tr class="separator:ab571412a681990a95131ded731ad6c4a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a70cfe1d5799d71ce3a0a62c244bb7ea8"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a70cfe1d5799d71ce3a0a62c244bb7ea8">Rollback</a> ()</td></tr>
<tr class="memdesc:a70cfe1d5799d71ce3a0a62c244bb7ea8"><td class="mdescLeft">&#160;</td><td class="mdescRight">Rolls back the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>.  <a href="#a70cfe1d5799d71ce3a0a62c244bb7ea8">More...</a><br/></td></tr>
<tr class="separator:a70cfe1d5799d71ce3a0a62c244bb7ea8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a94674fbf861328e85a249dd8c14ef6ea"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a94674fbf861328e85a249dd8c14ef6ea">RollbackTo</a> (string savepoint)</td></tr>
<tr class="memdesc:a94674fbf861328e85a249dd8c14ef6ea"><td class="mdescLeft">&#160;</td><td class="mdescRight">Rolls back the savepoint created by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or SaveTransactionPoint.  <a href="#a94674fbf861328e85a249dd8c14ef6ea">More...</a><br/></td></tr>
<tr class="separator:a94674fbf861328e85a249dd8c14ef6ea"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6813c9dd152354284ccdc96353bcfbdd"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a6813c9dd152354284ccdc96353bcfbdd">Release</a> (string savepoint)</td></tr>
<tr class="memdesc:a6813c9dd152354284ccdc96353bcfbdd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Releases a savepoint returned from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>. Releasing a savepoint makes changes since that savepoint permanent if the savepoint began the transaction, or otherwise the changes are permanent pending a call to <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>.  <a href="#a6813c9dd152354284ccdc96353bcfbdd">More...</a><br/></td></tr>
<tr class="separator:a6813c9dd152354284ccdc96353bcfbdd"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a2c8187a19b5065f6b23c079e7cca29fe"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe">Commit</a> ()</td></tr>
<tr class="memdesc:a2c8187a19b5065f6b23c079e7cca29fe"><td class="mdescLeft">&#160;</td><td class="mdescRight">Commits the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a>.  <a href="#a2c8187a19b5065f6b23c079e7cca29fe">More...</a><br/></td></tr>
<tr class="separator:a2c8187a19b5065f6b23c079e7cca29fe"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9132bae9e577ae479ddc6b919547759f"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a9132bae9e577ae479ddc6b919547759f">RunInTransaction</a> (Action action)</td></tr>
<tr class="memdesc:a9132bae9e577ae479ddc6b919547759f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">action</td><td>within a (possibly nested) transaction by wrapping it in a SAVEPOINT. If an exception occurs the whole transaction is rolled back, not just the current savepoint. The exception is rethrown. </td></tr>
  </table>
  </dd>
</dl>
 <a href="#a9132bae9e577ae479ddc6b919547759f">More...</a><br/></td></tr>
<tr class="separator:a9132bae9e577ae479ddc6b919547759f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a920c3f7421ad1c967730228abb5915fc"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a920c3f7421ad1c967730228abb5915fc">InsertAll</a> (System.Collections.IEnumerable objects)</td></tr>
<tr class="memdesc:a920c3f7421ad1c967730228abb5915fc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a920c3f7421ad1c967730228abb5915fc">More...</a><br/></td></tr>
<tr class="separator:a920c3f7421ad1c967730228abb5915fc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a62b62415941ce6486f7dfa219a69f1f1"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a62b62415941ce6486f7dfa219a69f1f1">InsertAll</a> (System.Collections.IEnumerable objects, string extra)</td></tr>
<tr class="memdesc:a62b62415941ce6486f7dfa219a69f1f1"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a62b62415941ce6486f7dfa219a69f1f1">More...</a><br/></td></tr>
<tr class="separator:a62b62415941ce6486f7dfa219a69f1f1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a08e03803dd01aa67ee56a8e6d184c9d9"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a08e03803dd01aa67ee56a8e6d184c9d9">InsertAll</a> (System.Collections.IEnumerable objects, Type objType)</td></tr>
<tr class="memdesc:a08e03803dd01aa67ee56a8e6d184c9d9"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a08e03803dd01aa67ee56a8e6d184c9d9">More...</a><br/></td></tr>
<tr class="separator:a08e03803dd01aa67ee56a8e6d184c9d9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a937382b36e6726d12fe6d09f7bfb0ab6"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a937382b36e6726d12fe6d09f7bfb0ab6">Insert</a> (object obj)</td></tr>
<tr class="memdesc:a937382b36e6726d12fe6d09f7bfb0ab6"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a937382b36e6726d12fe6d09f7bfb0ab6">More...</a><br/></td></tr>
<tr class="separator:a937382b36e6726d12fe6d09f7bfb0ab6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1c16c3dda43037326b7f2afc6c822abd"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c16c3dda43037326b7f2afc6c822abd">InsertOrReplace</a> (object obj)</td></tr>
<tr class="memdesc:a1c16c3dda43037326b7f2afc6c822abd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.  <a href="#a1c16c3dda43037326b7f2afc6c822abd">More...</a><br/></td></tr>
<tr class="separator:a1c16c3dda43037326b7f2afc6c822abd"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a19576a29af1c0891a646ff3e904f2cdc"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a19576a29af1c0891a646ff3e904f2cdc">Insert</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:a19576a29af1c0891a646ff3e904f2cdc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a19576a29af1c0891a646ff3e904f2cdc">More...</a><br/></td></tr>
<tr class="separator:a19576a29af1c0891a646ff3e904f2cdc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a812215a88043259b6a107994756000ae"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a812215a88043259b6a107994756000ae">InsertOrReplace</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:a812215a88043259b6a107994756000ae"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.  <a href="#a812215a88043259b6a107994756000ae">More...</a><br/></td></tr>
<tr class="separator:a812215a88043259b6a107994756000ae"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3ab0fde4b10c4b492b2f5f64535c6d66"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a3ab0fde4b10c4b492b2f5f64535c6d66">Insert</a> (object obj, string extra)</td></tr>
<tr class="memdesc:a3ab0fde4b10c4b492b2f5f64535c6d66"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a3ab0fde4b10c4b492b2f5f64535c6d66">More...</a><br/></td></tr>
<tr class="separator:a3ab0fde4b10c4b492b2f5f64535c6d66"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab88782cd2d5c77bb14d6a17baf7c49bc"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab88782cd2d5c77bb14d6a17baf7c49bc">Insert</a> (object obj, string extra, Type objType)</td></tr>
<tr class="memdesc:ab88782cd2d5c77bb14d6a17baf7c49bc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#ab88782cd2d5c77bb14d6a17baf7c49bc">More...</a><br/></td></tr>
<tr class="separator:ab88782cd2d5c77bb14d6a17baf7c49bc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae4effee772569a47256bcb5f8764eabc"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ae4effee772569a47256bcb5f8764eabc">Update</a> (object obj)</td></tr>
<tr class="memdesc:ae4effee772569a47256bcb5f8764eabc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.  <a href="#ae4effee772569a47256bcb5f8764eabc">More...</a><br/></td></tr>
<tr class="separator:ae4effee772569a47256bcb5f8764eabc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab474a534faebfec1288672ef4e4f2140"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab474a534faebfec1288672ef4e4f2140">Update</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:ab474a534faebfec1288672ef4e4f2140"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.  <a href="#ab474a534faebfec1288672ef4e4f2140">More...</a><br/></td></tr>
<tr class="separator:ab474a534faebfec1288672ef4e4f2140"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1a95399fe5d61f8bbb56e36eac38d467"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1a95399fe5d61f8bbb56e36eac38d467">UpdateAll</a> (System.Collections.IEnumerable objects)</td></tr>
<tr class="memdesc:a1a95399fe5d61f8bbb56e36eac38d467"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all specified objects.  <a href="#a1a95399fe5d61f8bbb56e36eac38d467">More...</a><br/></td></tr>
<tr class="separator:a1a95399fe5d61f8bbb56e36eac38d467"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a55234164e36bc4abcb086e197f25e436"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a55234164e36bc4abcb086e197f25e436">Delete</a> (object objectToDelete)</td></tr>
<tr class="memdesc:a55234164e36bc4abcb086e197f25e436"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes the given object from the database using its primary key.  <a href="#a55234164e36bc4abcb086e197f25e436">More...</a><br/></td></tr>
<tr class="separator:a55234164e36bc4abcb086e197f25e436"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0d4046198236b8c96b0bf50593f592a6"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a0d4046198236b8c96b0bf50593f592a6">Delete&lt; T &gt;</a> (object primaryKey)</td></tr>
<tr class="memdesc:a0d4046198236b8c96b0bf50593f592a6"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes the object with the specified primary key.  <a href="#a0d4046198236b8c96b0bf50593f592a6">More...</a><br/></td></tr>
<tr class="separator:a0d4046198236b8c96b0bf50593f592a6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abed406a2cd17e1e360b79924a749b67c"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abed406a2cd17e1e360b79924a749b67c">DeleteAll&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:abed406a2cd17e1e360b79924a749b67c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes all the objects from the specified table. WARNING WARNING: Let me repeat. It deletes ALL the objects from the specified table. Do you really want to do that?  <a href="#abed406a2cd17e1e360b79924a749b67c">More...</a><br/></td></tr>
<tr class="separator:abed406a2cd17e1e360b79924a749b67c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad9e1e281245e83dbe9c5303eaefe95f6"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ad9e1e281245e83dbe9c5303eaefe95f6">Dispose</a> ()</td></tr>
<tr class="separator:ad9e1e281245e83dbe9c5303eaefe95f6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a74160304a4a218b7508220106eeb10d0"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a74160304a4a218b7508220106eeb10d0">Close</a> ()</td></tr>
<tr class="separator:a74160304a4a218b7508220106eeb10d0"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-methods"></a>
Protected Member Functions</h2></td></tr>
<tr class="memitem:a7535db6cca83fcde078fa4340b32e982"><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a7535db6cca83fcde078fa4340b32e982">NewCommand</a> ()</td></tr>
<tr class="memdesc:a7535db6cca83fcde078fa4340b32e982"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>. Can be overridden to provide a sub-class.  <a href="#a7535db6cca83fcde078fa4340b32e982">More...</a><br/></td></tr>
<tr class="separator:a7535db6cca83fcde078fa4340b32e982"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab5e33e84b34867c48d1578d2890ff7e7"><td class="memItemLeft" align="right" valign="top">virtual void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab5e33e84b34867c48d1578d2890ff7e7">Dispose</a> (bool disposing)</td></tr>
<tr class="separator:ab5e33e84b34867c48d1578d2890ff7e7"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="properties"></a>
Properties</h2></td></tr>
<tr class="memitem:a504b348bb83df3b51fb49937db4d7804"><td class="memItemLeft" align="right" valign="top"><a class="el" href="_s_q_lite_8cs.html#a0137d4c5059675164f7580c64441f40c">Sqlite3DatabaseHandle</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a504b348bb83df3b51fb49937db4d7804">Handle</a><code> [get, set]</code></td></tr>
<tr class="separator:a504b348bb83df3b51fb49937db4d7804"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a18b410ed380268c16bb9bdb47b5ad44b"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a18b410ed380268c16bb9bdb47b5ad44b">DatabasePath</a><code> [get, set]</code></td></tr>
<tr class="separator:a18b410ed380268c16bb9bdb47b5ad44b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af925b9fddec261394ab29fbbaa25d9a0"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af925b9fddec261394ab29fbbaa25d9a0">TimeExecution</a><code> [get, set]</code></td></tr>
<tr class="separator:af925b9fddec261394ab29fbbaa25d9a0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af9e92ae222dba65b2ab761139531118a"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af9e92ae222dba65b2ab761139531118a">Trace</a><code> [get, set]</code></td></tr>
<tr class="separator:af9e92ae222dba65b2ab761139531118a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1c24728cf622f060629aac155e2afcaa"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c24728cf622f060629aac155e2afcaa">StoreDateTimeAsTicks</a><code> [get, set]</code></td></tr>
<tr class="separator:a1c24728cf622f060629aac155e2afcaa"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abb2b70df282aa2f1af07789db65db1dd"><td class="memItemLeft" align="right" valign="top">TimeSpan&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abb2b70df282aa2f1af07789db65db1dd">BusyTimeout</a><code> [get, set]</code></td></tr>
<tr class="memdesc:abb2b70df282aa2f1af07789db65db1dd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sleep multiple times until a total time of <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abb2b70df282aa2f1af07789db65db1dd" title="Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sl...">BusyTimeout</a> has accumulated.  <a href="#abb2b70df282aa2f1af07789db65db1dd">More...</a><br/></td></tr>
<tr class="separator:abb2b70df282aa2f1af07789db65db1dd"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ac0c3b1e8f8060ef9777fac08751d159e"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ac0c3b1e8f8060ef9777fac08751d159e">TableMappings</a><code> [get]</code></td></tr>
<tr class="memdesc:ac0c3b1e8f8060ef9777fac08751d159e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the mappings from types to tables that the connection currently understands.  <a href="#ac0c3b1e8f8060ef9777fac08751d159e">More...</a><br/></td></tr>
<tr class="separator:ac0c3b1e8f8060ef9777fac08751d159e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9450dfedb603c08eb75f57f36db41d9b"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a9450dfedb603c08eb75f57f36db41d9b">IsInTransaction</a><code> [get]</code></td></tr>
<tr class="memdesc:a9450dfedb603c08eb75f57f36db41d9b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Whether <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> has been called and the database is waiting for a <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>.  <a href="#a9450dfedb603c08eb75f57f36db41d9b">More...</a><br/></td></tr>
<tr class="separator:a9450dfedb603c08eb75f57f36db41d9b"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><p>Represents an open connection to a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00079">79</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>
</div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
<a class="anchor" id="a21204da14d0e2a44039f3395bb4ff12d"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">SQLite.SQLiteConnection.SQLiteConnection </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>databasePath</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">bool&#160;</td>
          <td class="paramname"><em>storeDateTimeAsTicks</em> = <code>false</code>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">databasePath</td><td>Specifies the path to the database file. </td></tr>
    <tr><td class="paramname">storeDateTimeAsTicks</td><td>Specifies whether to store DateTime properties as ticks (true) or strings (false). You absolutely do want to store them as Ticks in all new projects. The default of false is only here for backwards compatibility. There is a <em>significant</em> speed advantage, with no down sides, when setting storeDateTimeAsTicks = true. </td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00114">114</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a5d0deb6299d3f479e53cf81899023457"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">SQLite.SQLiteConnection.SQLiteConnection </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>databasePath</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="namespace_s_q_lite.html#a9d72cc097c53dbc96a6f0eec530cc439">SQLiteOpenFlags</a>&#160;</td>
          <td class="paramname"><em>openFlags</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">bool&#160;</td>
          <td class="paramname"><em>storeDateTimeAsTicks</em> = <code>false</code>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">databasePath</td><td>Specifies the path to the database file. </td></tr>
    <tr><td class="paramname">storeDateTimeAsTicks</td><td>Specifies whether to store DateTime properties as ticks (true) or strings (false). You absolutely do want to store them as Ticks in all new projects. The default of false is only here for backwards compatibility. There is a <em>significant</em> speed advantage, with no down sides, when setting storeDateTimeAsTicks = true. </td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00131">131</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<h2 class="groupheader">Member Function Documentation</h2>
<a class="anchor" id="aba3becdb524808bd49f349587f1b7049"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.BeginTransaction </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Begins a new transaction. Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a> to end the transaction. </p>
<p>Throws if a transaction has already begun.</p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00717">717</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a74160304a4a218b7508220106eeb10d0"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.Close </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01274">1274</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a2c8187a19b5065f6b23c079e7cca29fe"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.Commit </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Commits the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a>. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00880">880</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a112ac999fccd302bda742992f044f3ee"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> SQLite.SQLiteConnection.CreateCommand </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>cmdText</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>ps</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text with arguments. Place a '?' in the command text for each of the arguments. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">cmdText</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the command text. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00431">431</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a3e1bbdd7aebce4f815ca35b8277e1270"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.CreateTable </td>
          <td>(</td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>ty</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">ty</td><td>Type to reflect to a database table.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of entries added to the database schema. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00297">297</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a1a76c62e25bff4f6bbf5366175ab3bf7"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a3e1bbdd7aebce4f815ca35b8277e1270">SQLite.SQLiteConnection.CreateTable</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping. </p>
<dl class="section return"><dt>Returns</dt><dd>The number of entries added to the database schema. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00282">282</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab359d97e7938a573e0a565d2c46aa401"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">IEnumerable&lt;object&gt; SQLite.SQLiteConnection.DeferredQuery </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td>
          <td class="paramname"><em>map</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">map</td><td>A <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> to use to convert the resulting rows into objects. </td></tr>
    <tr><td class="paramname">query</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the query. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An enumerable with one result for each row returned by the query. The enumerator will call sqlite3_step on each call to MoveNext, so the database connection must remain open for the lifetime of the enumerator. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00600">600</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a334b139ead4620ad13b5e1d54e8077af"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">IEnumerable&lt;T&gt; <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab359d97e7938a573e0a565d2c46aa401">SQLite.SQLiteConnection.DeferredQuery</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">query</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the query. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An enumerable with one result for each row returned by the query. The enumerator will call sqlite3_step on each call to MoveNext, so the database connection must remain open for the lifetime of the enumerator. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00546">546</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a55234164e36bc4abcb086e197f25e436"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Delete </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>objectToDelete</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Deletes the given object from the database using its primary key. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">objectToDelete</td><td>The object to delete. It must have a primary key designated using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows deleted. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01206">1206</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a0d4046198236b8c96b0bf50593f592a6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a55234164e36bc4abcb086e197f25e436">SQLite.SQLiteConnection.Delete</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>primaryKey</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Deletes the object with the specified primary key. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">primaryKey</td><td>The primary key of the object to delete. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of objects deleted. </dd></dl>
<dl class="tparams"><dt>Template Parameters</dt><dd>
  <table class="tparams">
    <tr><td class="paramname">T</td><td>The type of object. </td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01229">1229</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="abed406a2cd17e1e360b79924a749b67c"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.DeleteAll&lt; T &gt; </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Deletes all the objects from the specified table. WARNING WARNING: Let me repeat. It deletes ALL the objects from the specified table. Do you really want to do that? </p>
<dl class="section return"><dt>Returns</dt><dd>The number of objects deleted. </dd></dl>
<dl class="tparams"><dt>Template Parameters</dt><dd>
  <table class="tparams">
    <tr><td class="paramname">T</td><td>The type of objects to delete. </td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01251">1251</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ad9e1e281245e83dbe9c5303eaefe95f6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.Dispose </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01263">1263</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab5e33e84b34867c48d1578d2890ff7e7"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">virtual void SQLite.SQLiteConnection.Dispose </td>
          <td>(</td>
          <td class="paramtype">bool&#160;</td>
          <td class="paramname"><em>disposing</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">protected</span><span class="mlabel">virtual</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01269">1269</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a783032226b2db2ebd6417f21abe9cd5a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.DropTable&lt; T &gt; </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Executes a "drop table" on the database. This is non-recoverable. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00264">264</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a5fbb3e385d21cfbee95e4a2a71a3043b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Execute </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. Use this method instead of Query when you don't expect rows back. Such cases include INSERTs, UPDATEs, and DELETEs. You can set the Trace or TimeExecution properties of the connection to profile execution. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">query</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the query. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows modified in the database as a result of this execution. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00462">462</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="af88acbe7da213c81875c3a35a5d61337"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">T SQLite.SQLiteConnection.ExecuteScalar&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00485">485</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a95729c5ebf5fad75631109db91e7c14b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">object SQLite.SQLiteConnection.Find </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>pk</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td>
          <td class="paramname"><em>map</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>). </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">pk</td><td>The primary key. </td></tr>
    <tr><td class="paramname">map</td><td>The <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> used to identify the object type. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The object with the given primary key or null if the object is not found. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00685">685</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="adfe66fe8c304aca8575f07fc1c05d9f5"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">T <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a95729c5ebf5fad75631109db91e7c14b">SQLite.SQLiteConnection.Find</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>pk</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>). </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">pk</td><td>The primary key. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The object with the given primary key or null if the object is not found. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00664">664</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">T <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a95729c5ebf5fad75631109db91e7c14b">SQLite.SQLiteConnection.Find</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">Expression&lt; Func&lt; T, bool &gt;&gt;&#160;</td>
          <td class="paramname"><em>predicate</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Attempts to retrieve the first object that matches the predicate from the table associated with the specified type. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">predicate</td><td>A predicate for which object to find. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The object that matches the given predicate or null if the object is not found. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00701">701</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a17fdec8364635853d573e84530e1ab48"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">T SQLite.SQLiteConnection.Get&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>pk</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>). </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">pk</td><td>The primary key. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The object with the given primary key. Throws a not found exception if the object is not found. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00630">630</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a4034d4b62385b2ab7451c5404ffb5efa"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">T SQLite.SQLiteConnection.Get&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">Expression&lt; Func&lt; T, bool &gt;&gt;&#160;</td>
          <td class="paramname"><em>predicate</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Attempts to retrieve the first object that matches the predicate from the table associated with the specified type. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">predicate</td><td>A predicate for which object to find. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The object that matches the given predicate. Throws a not found exception if the object is not found. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00647">647</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a25b7a6e9e1fa2e2ead47bb1821822fc6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> SQLite.SQLiteConnection.GetMapping </td>
          <td>(</td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>type</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Retrieves the mapping that is automatically generated for the given type. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">type</td><td>The type whose mapping to the database is returned. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The mapping represents the schema of the columns of the database and contains methods to set and get properties of objects. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00222">222</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="adf0ed08567e1ca36e4fda72c94ede544"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a25b7a6e9e1fa2e2ead47bb1821822fc6">SQLite.SQLiteConnection.GetMapping</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Retrieves the mapping that is automatically generated for the given type. </p>
<dl class="section return"><dt>Returns</dt><dd>The mapping represents the schema of the columns of the database and contains methods to set and get properties of objects. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00242">242</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="af85031e61990a4d11d10533da5acb21c"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">IEnumerable&lt;<a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_1_1_column_info.html">ColumnInfo</a>&gt; SQLite.SQLiteConnection.GetTableInfo </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>tableName</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00379">379</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a937382b36e6726d12fe6d09f7bfb0ab6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Insert </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00986">986</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a19576a29af1c0891a646ff3e904f2cdc"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Insert </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>objType</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
    <tr><td class="paramname">objType</td><td>The type of object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01028">1028</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a3ab0fde4b10c4b492b2f5f64535c6d66"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Insert </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>extra</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
    <tr><td class="paramname">extra</td><td>Literal SQL code that gets placed into the command. INSERT {extra} INTO ... </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01067">1067</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab88782cd2d5c77bb14d6a17baf7c49bc"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Insert </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>extra</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>objType</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
    <tr><td class="paramname">extra</td><td>Literal SQL code that gets placed into the command. INSERT {extra} INTO ... </td></tr>
    <tr><td class="paramname">objType</td><td>The type of object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01091">1091</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a920c3f7421ad1c967730228abb5915fc"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.InsertAll </td>
          <td>(</td>
          <td class="paramtype">System.Collections.IEnumerable&#160;</td>
          <td class="paramname"><em>objects</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts all specified objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">objects</td><td>An IEnumerable of the objects to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00919">919</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a62b62415941ce6486f7dfa219a69f1f1"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.InsertAll </td>
          <td>(</td>
          <td class="paramtype">System.Collections.IEnumerable&#160;</td>
          <td class="paramname"><em>objects</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>extra</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts all specified objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">objects</td><td>An IEnumerable of the objects to insert. </td></tr>
    <tr><td class="paramname">extra</td><td>Literal SQL code that gets placed into the command. INSERT {extra} INTO ... </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00942">942</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a08e03803dd01aa67ee56a8e6d184c9d9"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.InsertAll </td>
          <td>(</td>
          <td class="paramtype">System.Collections.IEnumerable&#160;</td>
          <td class="paramname"><em>objects</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>objType</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts all specified objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">objects</td><td>An IEnumerable of the objects to insert. </td></tr>
    <tr><td class="paramname">objType</td><td>The type of object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows added to the table. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00965">965</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a1c16c3dda43037326b7f2afc6c822abd"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.InsertOrReplace </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows modified. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01007">1007</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a812215a88043259b6a107994756000ae"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.InsertOrReplace </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>objType</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to insert. </td></tr>
    <tr><td class="paramname">objType</td><td>The type of object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows modified. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01049">1049</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a7535db6cca83fcde078fa4340b32e982"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">virtual <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> SQLite.SQLiteConnection.NewCommand </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">protected</span><span class="mlabel">virtual</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>. Can be overridden to provide a sub-class. </p>
<dl class="section see"><dt>See Also</dt><dd><a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html#a4761647a6b02f398aa1d7bbd1f090828" title="Invoked every time an instance is loaded from the database. ">SQLiteCommand.OnInstanceCreated</a></dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00413">413</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="aeac8a5ef1be5cfabc5bbf33f1fec01b0"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">List&lt;object&gt; SQLite.SQLiteConnection.Query </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td>
          <td class="paramname"><em>map</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">map</td><td>A <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> to use to convert the resulting rows into objects. </td></tr>
    <tr><td class="paramname">query</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the query. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An enumerable with one result for each row returned by the query. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00572">572</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ade363948abe65a6b97fe8574f943db91"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">List&lt;T&gt; <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aeac8a5ef1be5cfabc5bbf33f1fec01b0">SQLite.SQLiteConnection.Query</a>&lt; T &gt; </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>query</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params object[]&#160;</td>
          <td class="paramname"><em>args</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">query</td><td>The fully escaped SQL. </td></tr>
    <tr><td class="paramname">args</td><td>Arguments to substitute for the occurences of '?' in the query. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>An enumerable with one result for each row returned by the query. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00523">523</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a6813c9dd152354284ccdc96353bcfbdd"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.Release </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>savepoint</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Releases a savepoint returned from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>. Releasing a savepoint makes changes since that savepoint permanent if the savepoint began the transaction, or otherwise the changes are permanent pending a call to <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>. </p>
<p>The RELEASE command is like a COMMIT for a SAVEPOINT. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">savepoint</td><td>The name of the savepoint to release. The string should be the result of a call to <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00847">847</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a70cfe1d5799d71ce3a0a62c244bb7ea8"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.Rollback </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Rolls back the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00801">801</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a94674fbf861328e85a249dd8c14ef6ea"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.RollbackTo </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>savepoint</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Rolls back the savepoint created by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or SaveTransactionPoint. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">savepoint</td><td>The name of the savepoint to roll back to, as returned by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>. If savepoint is null or empty, this method is equivalent to a call to <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a70cfe1d5799d71ce3a0a62c244bb7ea8" title="Rolls back the transaction that was begun by BeginTransaction or SaveTransactionPoint. ">Rollback</a></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00810">810</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a9132bae9e577ae479ddc6b919547759f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void SQLite.SQLiteConnection.RunInTransaction </td>
          <td>(</td>
          <td class="paramtype">Action&#160;</td>
          <td class="paramname"><em>action</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Executes </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">action</td><td>within a (possibly nested) transaction by wrapping it in a SAVEPOINT. If an exception occurs the whole transaction is rolled back, not just the current savepoint. The exception is rethrown. </td></tr>
  </table>
  </dd>
</dl>
</p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">action</td><td>The Action to perform within a transaction. <dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">action</td><td>can contain any number of operations on the connection but should never call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>. </td></tr>
  </table>
  </dd>
</dl>
</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00898">898</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab571412a681990a95131ded731ad6c4a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string SQLite.SQLiteConnection.SaveTransactionPoint </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. </p>
<p>Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a94674fbf861328e85a249dd8c14ef6ea" title="Rolls back the savepoint created by BeginTransaction or SaveTransactionPoint. ">RollbackTo</a> to undo transactions since the returned savepoint. Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a6813c9dd152354284ccdc96353bcfbdd" title="Releases a savepoint returned from SaveTransactionPoint. Releasing a savepoint makes changes since th...">Release</a> to commit transactions after the savepoint returned here. Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a> to end the transaction, committing all changes. </p>
<dl class="section return"><dt>Returns</dt><dd>A string naming the savepoint.</dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00766">766</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab44d5100216c3cdcea76e45c6f7d6246"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">TableQuery&lt;T&gt; SQLite.SQLiteConnection.Table&lt; T &gt; </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Returns a queryable interface to the table represented by the given type. </p>
<dl class="section return"><dt>Returns</dt><dd>A queryable object that is able to translate Where, OrderBy, and Take queries into native SQL. </dd></dl>
<div class="typeconstraint">
<dl><dt><b>Type Constraints</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em>T</em></td><td>&#160;:</td><td valign="top"><em>new()</em></td><td>&#160;</td></tr>
</table>
</dl>
</div>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00613">613</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ae4effee772569a47256bcb5f8764eabc"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Update </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to update. It must have a primary key designated using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows updated. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01129">1129</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ab474a534faebfec1288672ef4e4f2140"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.Update </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"><em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">Type&#160;</td>
          <td class="paramname"><em>objType</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>The object to update. It must have a primary key designated using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>. </td></tr>
    <tr><td class="paramname">objType</td><td>The type of object to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows updated. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01151">1151</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a1a95399fe5d61f8bbb56e36eac38d467"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int SQLite.SQLiteConnection.UpdateAll </td>
          <td>(</td>
          <td class="paramtype">System.Collections.IEnumerable&#160;</td>
          <td class="paramname"><em>objects</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Updates all specified objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">objects</td><td>An IEnumerable of the objects to insert. </td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>The number of rows modified. </dd></dl>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l01186">1186</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<h2 class="groupheader">Property Documentation</h2>
<a class="anchor" id="abb2b70df282aa2f1af07789db65db1dd"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">TimeSpan SQLite.SQLiteConnection.BusyTimeout</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sleep multiple times until a total time of <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abb2b70df282aa2f1af07789db65db1dd" title="Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sl...">BusyTimeout</a> has accumulated. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00188">188</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a18b410ed380268c16bb9bdb47b5ad44b"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">string SQLite.SQLiteConnection.DatabasePath</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00094">94</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a504b348bb83df3b51fb49937db4d7804"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="_s_q_lite_8cs.html#a0137d4c5059675164f7580c64441f40c">Sqlite3DatabaseHandle</a> SQLite.SQLiteConnection.Handle</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00091">91</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a9450dfedb603c08eb75f57f36db41d9b"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">bool SQLite.SQLiteConnection.IsInTransaction</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Whether <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> has been called and the database is waiting for a <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00709">709</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a1c24728cf622f060629aac155e2afcaa"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">bool SQLite.SQLiteConnection.StoreDateTimeAsTicks</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00100">100</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ac0c3b1e8f8060ef9777fac08751d159e"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">IEnumerable&lt;<a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&gt; SQLite.SQLiteConnection.TableMappings</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Returns the mappings from types to tables that the connection currently understands. </p>

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00202">202</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="af925b9fddec261394ab29fbbaa25d9a0"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">bool SQLite.SQLiteConnection.TimeExecution</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00096">96</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<a class="anchor" id="af9e92ae222dba65b2ab761139531118a"></a>
<div class="memitem">
<div class="memproto">
<table class="mlabels">
  <tr>
  <td class="mlabels-left">
      <table class="memname">
        <tr>
          <td class="memname">bool SQLite.SQLiteConnection.Trace</td>
        </tr>
      </table>
  </td>
  <td class="mlabels-right">
<span class="mlabels"><span class="mlabel">get</span><span class="mlabel">set</span></span>  </td>
  </tr>
</table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_8cs_source.html#l00098">98</a> of file <a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li><a class="el" href="_s_q_lite_8cs_source.html">SQLite.cs</a></li>
</ul>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="namespace_s_q_lite.html">SQLite</a></li><li class="navelem"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLiteConnection</a></li>
    <li class="footer">Generated on Thu Dec 26 2013 14:21:49 for SystemSharp by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li>
  </ul>
</div>
</body>
</html>
